Skip to main content
This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

Notes/Domino 6 and 7 Forum

Notes/Domino 6 and 7 Forum


PreviousPrevious NextNext

RE: Notes & Crystal Reports
~Lisa Desfreemanader 24.Jan.04 08:20 AM a Web browser
Domino Designer 6.5 All Platforms

Crystal Report can query Notes Database with a NotesSQL driver. Create Crytal Report Control in the form in which you are generating report. Using object routines, you can pass parametrs, specify the path of the file, NotesSQL driver name to the crystal report you designed.

I am putting a sample code for you here.

'Report is the name of the control
Dim ctl As Variant
Set ctl = uidoc.GetObject("Report")
'ls_ReportFrom is a string holds a date
'StartDate is crystal report parameterof type Date
ctl.parameterfields(0)="StartDate;date("+Cstr(Year(ls_ReportFrom))+","+Cstr(Month(ls_ReportFrom))+","+Cstr(Day(ls_ReportFrom))+")" +";True"
'Activity is a parametr in crystal report parameter of type String
ctl.reportfilename="C:/Reports/Detailed Report.rpt"
ctl.connect="dsn=" & NotesSQL1
ctl.WindowState = 2
ctl.Action = 1

Hope, this helps you to generate report that you would like to.


Notes & Crystal Reports (~Dana Rejumimar... 23.Jan.04)
. . RE: Notes & Crystal Reports (~Mario Lopkiste... 23.Jan.04)
. . . . RE: Notes & Crystal Reports (~Lisa Desfreema... 24.Jan.04)

Document Options

  Document options
Print this pagePrint this page

Search this forum

Forum views and search

  Forum views and search
Date (threaded)
Date (flat)
With excerpt
Advanced search

Member Tools

RSS Feeds

 RSS feedsRSS
All forum posts RSS
All main topics RSS